<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Creating a report that accesses an Intelligent Cube</title>
<link rel="stylesheet" href="default_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='default.css'>");}
//-->
</script>
<style type="text/css">
<!--
h1.whs1 { font-size:11pt; }
p.whs2 { font-size:9pt; }
p.whs3 { font-size:9pt; font-weight:bold; }
ul.whs4 { list-style:disc; }
p.whs5 { margin-top:6px; margin-bottom:6px; }
h2.whs6 { font-size:10pt; }
ol.whs7 { list-style:decimal; }
p.whs8 { font-size:9pt; margin-top:4.5pt; margin-bottom:4.5pt; }
p.whs9 { margin-top:4.5pt; margin-bottom:4.5pt; font-size:9pt; }
p.whs10 { font-size:9pt; margin-top:4.5pt; margin-bottom:4.5pt; margin-left:40px; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying reports\nCreating a grid or graph report\nCreating a report that accesses an Intelligent Cube");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1 class="whs1">
<a name=Creating_a_report_that_accesses_an_Intelligent_Cube></a>Creating 
 a report that accesses an Intelligent Cube </h1>
<p class="whs2"><span style="font-size: 9pt;"><font size=1 style="font-size:9pt;">You can perform 
 all of your reporting and data analysis requirements within an Intelligent 
 Cube without executing against the data warehouse. Once an Intelligent 
 Cube is created and then published so its data is available, multiple 
 reports can be created to connect to the Intelligent Cube.</font></span></p>
<p class="whs2">&nbsp;</p>
<p class="whs2">Reporting on a shared Intelligent Cube provides 
 quick access to data as the data has been pre-aggregated. This returns 
 report results much faster than querying the data warehouse. Reporting 
 on Intelligent Cubes also allows you to use all of the OLAP Services features, 
 including derived elements. Derived elements allow you to group attribute 
 elements in a report on-the-fly to provide a new view of report data for 
 analysis and formatting purposes.</p>
<p class="whs2">&nbsp;</p>
<p class="whs2">Reports that connect to an Intelligent Cube 
 are restricted to only the data available within the Intelligent Cube. 
 This ensures that report results are returned quickly, and it also prevents 
 full ROLAP analysis. Report filters, consolidations, and custom groups 
 are not available for reports that connect to Intelligent Cubes. For a 
 full comparison of personal Intelligent Cubes and Intelligent Cubes, see 
 the <span style="font-style: italic;"><I>OLAP Services Guide</I></span>.</p>
<p class="whs2">&nbsp;</p>
<p class="whs3">Warning: <span style="font-weight: normal;">If 
 security filters are used to maintain data access security, there are 
 some differences in security filter resolution for reports connected to 
 Intelligent Cubes. For information on these differences, see the </span><span 
 style="font-weight: normal; font-style: italic;"><I>OLAP Services Guide</I></span><span 
 style="font-weight: normal;">.</span></p>
<p class="whs2">&nbsp;</p>
<p class="whs3">Prerequisites</p>
<ul type="disc" class="whs4">
	
<li class=p><p class="whs5">You must 
 have a Web Professional license and the Web Define Intelligent Cube Report 
 Web Professional privilege to create a report from a cube source.</p></li>
	
<li class=p><p class="whs5">You must 
 own the MicroStrategy OLAP Services product.</p></li>
	
<li class=p><p class="whs5">An Intelligent 
 Cube has been created and published.</p></li>
</ul>
<h2 class="whs6">To create a report that accesses an Intelligent 
 Cube</h2>
<ol type="1" class="whs7">
	
<li style=" font-size: 9pt; " class=p><p class="whs8">In 
 the <span style="font-weight: bold;"><B>Shared Reports</B></span> folder, click 
 <span style="font-weight: bold;"><B>Create Report</B></span>. </p></li>
	
<li style=" font-size: 9pt; " class=p><p class="whs8">Click 
 <span style="font-weight: bold;"><B>Choose Intelligent Cube</B></span>. The Select 
 Cube Report dialog box opens. </p></li>
	
<li style=" font-size: 9pt; " class=p><p class="whs8">Browse 
 to and select a previously saved Intelligent Cube on which to build your 
 report.</p></li>
	
<li style=" font-size: 9pt; " class=p><p class="whs8">Click 
 <span style="font-weight: bold;"><B>OK</B></span>. The report opens with all 
 the objects of the Intelligent Cube included in the Report Objects pane 
 on the left.</p></li>
	
<li style=" font-size: 9pt; " class=p><p class="whs8">Drag 
 and drop the objects into the report grid from the Report Objects pane. 
 </p></li>
	
<li style=" font-size: 9pt; " class=p><p class="whs9">Click 
 <span style="font-weight: bold;"><B>Run Report</B></span>.</p></li>
</ol>
<p class="whs8">&nbsp;</p>
<p class="whs8"><span 
 style="font-weight: bold;"><B>Related</B></span> <span style="font-weight: bold;"><B>topics</B></span></p>
<ul type="disc" class="whs4">
	
<li class=p><p class="whs9">
<a 
 href="Creating_a_new_report.htm">Creating a report</a></p></li>
	
<li class=p><p class="whs8">
<a 
 href="Creating_a_report_using_a_template.htm">Creating a report using 
 a template</a></p></li>
	
<li class=p><p class="whs8">
<a 
 href="Creating_an_OLAP_Cube_report.htm">Creating MDX cube reports</a></p></li>
</ul>
<p class="whs10">&nbsp;</p>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
